select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 10000 and a.houseprice <= 20000) and (b.cnpropertyname like '%North Xiangyang Rd Old House%' or b.enpropertyname like '%North Xiangyang Rd Old House%') order by updateTime Desc, a.dftpic desc
The most attractive apartment in french concession,very luxury decor equiped with all the basic home appliance,huge and bright living room highlight the atmosph...
Located at the top position of the Mid Huaihai Rd Area. This recently renovated two bedroom paradise has an easy access to the subway, shopping, restaurants, a...